<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html lang="en">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <title>LCOV - 覆盖率信息 - Pool/sqlconnpool.cpp</title>
  <link rel="stylesheet" type="text/css" href="../gcov.css">
</head>

<body>

          <table width="100%" border=0 cellspacing=0 cellpadding=0>
            <tr><td class="title">LCOV - code coverage report</td></tr>
            <tr><td class="ruler"><img src="../glass.png" width=3 height=3 alt=""></td></tr>

            <tr>
              <td width="100%">
                <table cellpadding=1 border=0 width="100%">
          <tr>
            <td width="10%" class="headerItem">Current view:</td>
            <td width="10%" class="headerValue"><a href="../index.html" title="Click to go to top-level">top level</a> - <a href="index.html" title="Click to go to directory Pool">Pool</a> - sqlconnpool.cpp<span style="font-size: 80%;"> (source / <a href="sqlconnpool.cpp.func-c.html" title="Click to go to function table">functions</a>)</span></td>
            <td width="5%"></td>
            <td width="5%"></td>
            <td width="5%" class="headerCovTableHead">Coverage</td>
            <td width="5%" class="headerCovTableHead" title="Covered + Uncovered code">Total</td>
            <td width="5%" class="headerCovTableHead" title="Exercised code only">Hit</td>
          </tr>
          <tr>
            <td class="headerItem">Test:</td>
            <td class="headerValue">覆盖率信息</td>
            <td></td>
            <td class="headerItem">Lines:</td>
            <td class="headerCovTableEntryHi">90.7&nbsp;%</td>
            <td class="headerCovTableEntry">54</td>
            <td class="headerCovTableEntry">49</td>
          </tr>
          <tr>
            <td class="headerItem">Test Date:</td>
            <td class="headerValue">2024-03-12 16:43:50</td>
            <td></td>
            <td class="headerItem">Functions:</td>
            <td class="headerCovTableEntryHi">100.0&nbsp;%</td>
            <td class="headerCovTableEntry">8</td>
            <td class="headerCovTableEntry">8</td>
          </tr>
          <tr>
            <td class="headerItem">Legend:</td>
            <td class="headerValueLeg">            Lines:
            <span class="coverLegendCov">hit</span>
            <span class="coverLegendNoCov">not hit</span>
            | Branches:
            <span class="coverLegendCov">+</span> taken
            <span class="coverLegendNoCov">-</span> not taken
            <span class="coverLegendNoCov">#</span> not executed
</td>
            <td></td>
            <td class="headerItem">Branches:</td>
            <td class="headerCovTableEntryLo">27.3&nbsp;%</td>
            <td class="headerCovTableEntry">88</td>
            <td class="headerCovTableEntry">24</td>
          </tr>
                  <tr><td><img src="../glass.png" width=3 height=3 alt=""></td></tr>
                </table>
              </td>
            </tr>

            <tr><td class="ruler"><img src="../glass.png" width=3 height=3 alt=""></td></tr>
          </table>

          <table cellpadding=0 cellspacing=0 border=0>
            <tr>
              <td><br></td>
            </tr>
            <tr>
              <td>
<pre class="sourceHeading">             Branch data     Line data    Source code</pre>
<pre class="source">
<span id="L1"><span class="lineNum">       1</span>                 :             : #include &quot;sqlconnpool.h&quot;</span>
<span id="L2"><span class="lineNum">       2</span>                 :             : using namespace std;</span>
<span id="L3"><span class="lineNum">       3</span>                 :             : </span>
<span id="L4"><span class="lineNum">       4</span>                 :<span class="tlaGNC tlaBgGNC">           1 : SqlConnPool::SqlConnPool() {</span></span>
<span id="L5"><span class="lineNum">       5</span>                 :<span class="tlaGNC">           1 :     useCount_ = 0; </span></span>
<span id="L6"><span class="lineNum">       6</span>                 :<span class="tlaGNC">           1 :     freeCount_ = 0;</span></span>
<span id="L7"><span class="lineNum">       7</span>                 :<span class="tlaGNC">           1 : }</span></span>
<span id="L8"><span class="lineNum">       8</span>                 :             : </span>
<span id="L9"><span class="lineNum">       9</span>                 :             : // 单例模式，懒汉方式</span>
<span id="L10"><span class="lineNum">      10</span>                 :<span class="tlaGNC">           5 : SqlConnPool* SqlConnPool::Instance() {</span></span>
<span id="L11"><span class="lineNum">      11</span>   [<span class="tlaGBC" title="Branch 0 was taken 1 time"> + </span><span class="tlaGBC" title="Branch 1 was taken 4 times"> + </span><span class="tlaGBC" title="Branch 2 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 3 was not taken"> - </span> :<span class="tlaGNC">           5 :     static SqlConnPool connPool;</span></span>
<span class="lineNum">        </span>    <span class="tlaGBC" title="Branch 4 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 5 was not taken"> - </span><span class="tlaUNC" title="Branch 6 was not taken"> - </span><span class="tlaUNC" title="Branch 7 was not taken"> - </span>]
<span id="L12"><span class="lineNum">      12</span>                 :<span class="tlaGNC">           5 :     return &amp;connPool;</span></span>
<span id="L13"><span class="lineNum">      13</span>                 :             : }</span>
<span id="L14"><span class="lineNum">      14</span>                 :             : </span>
<span id="L15"><span class="lineNum">      15</span>                 :<span class="tlaGNC">           1 : void SqlConnPool::Init(const char* host, int port, const char* user,</span></span>
<span id="L16"><span class="lineNum">      16</span>                 :             :             const char* pwd, const char* dbName, int connSize = 10) {</span>
<span id="L17"><span class="lineNum">      17</span>         [<span class="tlaUNC" title="Branch 0 was not taken"> - </span><span class="tlaGBC" title="Branch 1 was taken 1 time"> + </span>]:<span class="tlaGNC">           1 :     assert(connSize &gt; 0);</span></span>
<span id="L18"><span class="lineNum">      18</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaGBC" title="Branch 1 was taken 1 time"> + </span>]:<span class="tlaGNC">           6 :     for(int i = 0; i &lt; connSize; i++) {     // 创造SQL连接</span></span>
<span id="L19"><span class="lineNum">      19</span>                 :<span class="tlaGNC">           5 :         MYSQL* sql = nullptr;</span></span>
<span id="L20"><span class="lineNum">      20</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           5 :         sql = mysql_init(sql);              //初始化</span></span>
<span id="L21"><span class="lineNum">      21</span>         [<span class="tlaUNC" title="Branch 0 was not taken"> - </span><span class="tlaGBC" title="Branch 1 was taken 5 times"> + </span>]:<span class="tlaGNC">           5 :         if(!sql) {</span></span>
<span id="L22"><span class="lineNum">      22</span>   [<span class="tlaUNC" title="Branch 0 was not executed"> # </span><span class="tlaUNC" title="Branch 1 was not executed"> # </span><span class="tlaUNC" title="Branch 2 was not executed"> # </span><span class="tlaUNC" title="Branch 3 was not executed"> # </span> :<span class="tlaUNC tlaBgUNC">           0 :             LOG_ERROR(&quot;MySql init error!&quot;); //写日志</span></span>
<span class="lineNum">        </span> <span class="tlaUNC" title="Branch 4 was not executed"> # </span><span class="tlaUNC" title="Branch 5 was not executed"> # </span><span class="tlaUNC" title="Branch 6 was not executed"> # </span><span class="tlaUNC" title="Branch 7 was not executed"> # </span><span class="tlaUNC" title="Branch 8 was not executed"> # </span> 
<span class="lineNum">        </span>    <span class="tlaUNC" title="Branch 9 was not executed"> # </span><span class="tlaUNC" title="Branch 10 was not executed"> # </span><span class="tlaUNC" title="Branch 11 was not executed"> # </span><span class="tlaUNC" title="Branch 12 was not executed"> # </span> 
<span class="lineNum">        </span>             <span class="tlaUNC" title="Branch 13 was not executed"> # </span>]
<span id="L23"><span class="lineNum">      23</span>         [<span class="tlaUNC" title="Branch 0 was not executed"> # </span><span class="tlaUNC" title="Branch 1 was not executed"> # </span>]:<span class="tlaUNC">           0 :             assert(sql);</span></span>
<span id="L24"><span class="lineNum">      24</span>                 :             :         }</span>
<span id="L25"><span class="lineNum">      25</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC tlaBgGNC">           5 :         sql = mysql_real_connect(sql, host, user, pwd, dbName,</span></span>
<span id="L26"><span class="lineNum">      26</span>                 :             :                                     port, nullptr, 0);</span>
<span id="L27"><span class="lineNum">      27</span>         [<span class="tlaUNC" title="Branch 0 was not taken"> - </span><span class="tlaGBC" title="Branch 1 was taken 5 times"> + </span>]:<span class="tlaGNC">           5 :         if(!sql) {</span></span>
<span id="L28"><span class="lineNum">      28</span>   [<span class="tlaUNC" title="Branch 0 was not executed"> # </span><span class="tlaUNC" title="Branch 1 was not executed"> # </span><span class="tlaUNC" title="Branch 2 was not executed"> # </span><span class="tlaUNC" title="Branch 3 was not executed"> # </span> :<span class="tlaUNC tlaBgUNC">           0 :             LOG_ERROR(&quot;MySql Connect error!&quot;);</span></span>
<span class="lineNum">        </span> <span class="tlaUNC" title="Branch 4 was not executed"> # </span><span class="tlaUNC" title="Branch 5 was not executed"> # </span><span class="tlaUNC" title="Branch 6 was not executed"> # </span><span class="tlaUNC" title="Branch 7 was not executed"> # </span><span class="tlaUNC" title="Branch 8 was not executed"> # </span> 
<span class="lineNum">        </span>    <span class="tlaUNC" title="Branch 9 was not executed"> # </span><span class="tlaUNC" title="Branch 10 was not executed"> # </span><span class="tlaUNC" title="Branch 11 was not executed"> # </span><span class="tlaUNC" title="Branch 12 was not executed"> # </span> 
<span class="lineNum">        </span>             <span class="tlaUNC" title="Branch 13 was not executed"> # </span>]
<span id="L29"><span class="lineNum">      29</span>                 :             :         }</span>
<span id="L30"><span class="lineNum">      30</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC tlaBgGNC">           5 :         connQue_.push(sql);     // 让该sql连接进入队列</span></span>
<span id="L31"><span class="lineNum">      31</span>                 :             :     }</span>
<span id="L32"><span class="lineNum">      32</span>                 :<span class="tlaGNC">           1 :     MAX_CONN_ = connSize;</span></span>
<span id="L33"><span class="lineNum">      33</span>                 :<span class="tlaGNC">           1 :     sem_init(&amp;semId_, 0, MAX_CONN_);    // 初始化为10</span></span>
<span id="L34"><span class="lineNum">      34</span>                 :<span class="tlaGNC">           1 : }</span></span>
<span id="L35"><span class="lineNum">      35</span>                 :             : </span>
<span id="L36"><span class="lineNum">      36</span>                 :<span class="tlaGNC">           1 : MYSQL* SqlConnPool::GetConn() {</span></span>
<span id="L37"><span class="lineNum">      37</span>                 :<span class="tlaGNC">           1 :     MYSQL* sql = nullptr;</span></span>
<span id="L38"><span class="lineNum">      38</span>         [<span class="tlaUNC" title="Branch 0 was not taken"> - </span><span class="tlaGBC" title="Branch 1 was taken 1 time"> + </span>]:<span class="tlaGNC">           1 :     if(connQue_.empty()) {      // 没有连接建立</span></span>
<span id="L39"><span class="lineNum">      39</span>   [<span class="tlaUNC" title="Branch 0 was not executed"> # </span><span class="tlaUNC" title="Branch 1 was not executed"> # </span><span class="tlaUNC" title="Branch 2 was not executed"> # </span><span class="tlaUNC" title="Branch 3 was not executed"> # </span> :<span class="tlaUNC tlaBgUNC">           0 :         LOG_WARN(&quot;SqlCoonPool busy!&quot;); </span></span>
<span class="lineNum">        </span> <span class="tlaUNC" title="Branch 4 was not executed"> # </span><span class="tlaUNC" title="Branch 5 was not executed"> # </span><span class="tlaUNC" title="Branch 6 was not executed"> # </span><span class="tlaUNC" title="Branch 7 was not executed"> # </span><span class="tlaUNC" title="Branch 8 was not executed"> # </span> 
<span class="lineNum">        </span>    <span class="tlaUNC" title="Branch 9 was not executed"> # </span><span class="tlaUNC" title="Branch 10 was not executed"> # </span><span class="tlaUNC" title="Branch 11 was not executed"> # </span><span class="tlaUNC" title="Branch 12 was not executed"> # </span> 
<span class="lineNum">        </span>             <span class="tlaUNC" title="Branch 13 was not executed"> # </span>]
<span id="L40"><span class="lineNum">      40</span>                 :<span class="tlaUNC">           0 :         return nullptr;</span></span>
<span id="L41"><span class="lineNum">      41</span>                 :             :     }</span>
<span id="L42"><span class="lineNum">      42</span>         [<span class="tlaGBC" title="Branch 0 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC tlaBgGNC">           1 :     sem_wait(&amp;semId_);              // 阻塞等待连接数量大于零</span></span>
<span id="L43"><span class="lineNum">      43</span>         [<span class="tlaGBC" title="Branch 0 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           1 :     lock_guard&lt;mutex&gt; locker(mtx_); // 锁定</span></span>
<span id="L44"><span class="lineNum">      44</span>                 :<span class="tlaGNC">           1 :     sql = connQue_.front();         // 得到队头连接</span></span>
<span id="L45"><span class="lineNum">      45</span>                 :<span class="tlaGNC">           1 :     connQue_.pop();                 // 清除连接</span></span>
<span id="L46"><span class="lineNum">      46</span>                 :<span class="tlaGNC">           1 :     return sql;</span></span>
<span id="L47"><span class="lineNum">      47</span>                 :<span class="tlaGNC">           1 : }</span></span>
<span id="L48"><span class="lineNum">      48</span>                 :             : </span>
<span id="L49"><span class="lineNum">      49</span>                 :<span class="tlaGNC">           1 : void SqlConnPool::FreeConn(MYSQL* sql) {</span></span>
<span id="L50"><span class="lineNum">      50</span>         [<span class="tlaUNC" title="Branch 0 was not taken"> - </span><span class="tlaGBC" title="Branch 1 was taken 1 time"> + </span>]:<span class="tlaGNC">           1 :     assert(sql);</span></span>
<span id="L51"><span class="lineNum">      51</span>         [<span class="tlaGBC" title="Branch 0 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           1 :     lock_guard&lt;mutex&gt; locker(mtx_);</span></span>
<span id="L52"><span class="lineNum">      52</span>         [<span class="tlaGBC" title="Branch 0 was taken 1 time"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           1 :     connQue_.push(sql);     // 将使用完的连接加入队列</span></span>
<span id="L53"><span class="lineNum">      53</span>                 :<span class="tlaGNC">           1 :     sem_post(&amp;semId_);      // 可用连接+1</span></span>
<span id="L54"><span class="lineNum">      54</span>                 :<span class="tlaGNC">           1 : }</span></span>
<span id="L55"><span class="lineNum">      55</span>                 :             : </span>
<span id="L56"><span class="lineNum">      56</span>                 :<span class="tlaGNC">           2 : void SqlConnPool::ClosePool() {</span></span>
<span id="L57"><span class="lineNum">      57</span>         [<span class="tlaGBC" title="Branch 0 was taken 2 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           2 :     lock_guard&lt;mutex&gt; locker(mtx_);</span></span>
<span id="L58"><span class="lineNum">      58</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaGBC" title="Branch 1 was taken 2 times"> + </span>]:<span class="tlaGNC">           7 :     while(!connQue_.empty()) {</span></span>
<span id="L59"><span class="lineNum">      59</span>                 :<span class="tlaGNC">           5 :         auto item = connQue_.front();</span></span>
<span id="L60"><span class="lineNum">      60</span>                 :<span class="tlaGNC">           5 :         connQue_.pop();</span></span>
<span id="L61"><span class="lineNum">      61</span>         [<span class="tlaGBC" title="Branch 0 was taken 5 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           5 :         mysql_close(item);</span></span>
<span id="L62"><span class="lineNum">      62</span>                 :             :     }</span>
<span id="L63"><span class="lineNum">      63</span>         [<span class="tlaGBC" title="Branch 0 was taken 2 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           2 :     mysql_library_end();</span></span>
<span id="L64"><span class="lineNum">      64</span>                 :<span class="tlaGNC">           2 : }</span></span>
<span id="L65"><span class="lineNum">      65</span>                 :             : </span>
<span id="L66"><span class="lineNum">      66</span>                 :<span class="tlaGNC">           2 : int SqlConnPool::GetFreeConnCount() {</span></span>
<span id="L67"><span class="lineNum">      67</span>         [<span class="tlaGBC" title="Branch 0 was taken 2 times"> + </span><span class="tlaUNC" title="Branch 1 was not taken"> - </span>]:<span class="tlaGNC">           2 :     lock_guard&lt;mutex&gt; locker(mtx_);</span></span>
<span id="L68"><span class="lineNum">      68</span>                 :<span class="tlaGNC">           4 :     return connQue_.size();</span></span>
<span id="L69"><span class="lineNum">      69</span>                 :<span class="tlaGNC">           2 : }</span></span>
<span id="L70"><span class="lineNum">      70</span>                 :             : </span>
<span id="L71"><span class="lineNum">      71</span>                 :<span class="tlaGNC">           1 : SqlConnPool::~SqlConnPool() {</span></span>
<span id="L72"><span class="lineNum">      72</span>                 :<span class="tlaGNC">           1 :     ClosePool();</span></span>
<span id="L73"><span class="lineNum">      73</span>                 :<span class="tlaGNC">           1 : }</span></span>
        </pre>
              </td>
            </tr>
          </table>
          <br>

          <table width="100%" border=0 cellspacing=0 cellpadding=0>
            <tr><td class="ruler"><img src="../glass.png" width=3 height=3 alt=""></td></tr>
            <tr><td class="versionInfo">Generated by: <a href="https://github.com//linux-test-project/lcov" target="_parent">LCOV version 2.0-136.g49608c4</a></td></tr>
          </table>
          <br>

</body>
</html>
